In this step, we will create a map and charts in the 2nd dashboard / page.
Step 1 - Average Violent Crimes Per Day by Group Line and Clustered Column chart
Visualizations
Click the Line and Clustered Column chart icon
Fields
Select the following:
A_KeyMeasures -> .AVG_Violent_Crimes_PerDay - Under Visualizations, drag & drop it in the Column Values section.
A_KeyMeasures -> .YOY_Violent_Crimes% - Under Visualizations, drag & drop it in the Line Values section.Raleigh_Police_Incidents_NIBRS -> Crime_Category - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> Crime_Description - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> reported_hour - Under Visualizations, drag & drop it in the Shared Axis section
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.AVG_Violent_Crimes_PerDay = Avg Violent Crimes/Day
Crime_Category = Crime Category
Crime_Description = Crime Description
reported_dayofwk = Reported Day of the Week
reported_hour = Reported Hour
Visualization Listing
For Line and Clustered Column chart, have the visualizations listed in the following order:
Visualizations
Format tab
Similar to the previously created Line and Clustered Column charts, set up the format:
Under Format -> General: X Position = 225 , Y Position = 144 , Width = 539 , Height = 437
Under
Format -> Legend -> Set it to ON , Position = Top Center , Color
= 000000 , Font Family = Segoe UI , Text Size = 11 pt , Style = Markers
Only
Under Format -> X Axis -> Color = 000000 , Text Size = 10 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Y Axis
-> Position = Left , Scale Type = Linear -> Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF ,
Style
= Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position =
Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font
Family = Segoe UI , Title = OFF
Under Format -> Data Colors -> YOY Violent Crimes = 6B007B , Default Color = CF6B7D
Under Format -> Data Labels -> Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Show Background = Off ,
Customize Series = ON ,
(Select Average Violent Crimes Per Day -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,
(Select YOY Violent Crimes -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,Under Format -> Shapes ->
Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style =
Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666
Summary:
Filters
NoneStep 2 - Create Top Average Major Crimes Per Day by Group Line and Clustered Column chart
To get you started, use the previous chart as a template. Click on the Average Violent Crimes Per Day by Group Line and Clustered Column chart, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied chart, set up as follows:
Visualizations
Fields
Select the following:
A_KeyMeasures -> .AVG_Major_Crimes_PerDay - Under Visualizations, drag & drop it in the Column Values section.
A_KeyMeasures -> .YOY_Major_Crimes% - Under Visualizations, drag & drop it in the Line Values section.Raleigh_Police_Incidents_NIBRS -> Crime_Category - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> Crime_Description - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> reported_hour - Under Visualizations, drag & drop it in the Shared Axis section
Visualization Listing
For Line and Clustered Column chart, have the visualizations listed in the following order:
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.AVG_Major_Crimes_PerDay = Avg Major Crimes Per Day
Crime_Category = Crime Category
Crime_Description = Crime Description
reported_dayofwk = Reported Day of the Week
reported_hour = Reported Hour
Format tab
Similar to the previously created Line and Clustered Column charts, set up the format:
Under Format -> General: X Position = 225 , Y Position = 581 , Width = 1175 , Height = 365
Under
Format -> Legend -> Set it to ON , Position = Top Center , Color
= 000000 , Font Family = Segoe UI , Text Size = 11 pt , Style = Markers
Only
Under Format -> X Axis -> Color =
000000 , Text Size = 10 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Y Axis
-> Position = Left , Scale Type = Linear -> Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF ,
Style
= Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 ,
Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position =
Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font
Family = Segoe UI , Title = OFF
Under Format -> Data Colors -> YOY Major Crimes = 0D6ABF, Default Color = 70BBFF
Under Format -> Data Labels -> Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Show Background = Off ,
Customize Series = ON ,
(Select Average Major Crimes Per Day -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,
(Select YOY Major Crimes -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,Under Format -> Shapes ->
Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style =
Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666
Summary:
Step 3 - Add filter(s)
Filters
Under Filters -> Crime Category -> Filter Type = Top N -> Show items = Top and enter 20 , By Value = A_KeyMeasures -> .AVG_Major_Crimes_PerDayStep 4 -
Sorting
Sort by Reported Day of the week.
When finished, save project.